What Day of the Week Is It?

When Did I do This?

What if you’re using Excel to track the hours you are working for a customer. Naturally, you will use Excel’s date formatting in column A , # of hours worked column, a rate/hour column, a formula to calculate that day’s billing amount and a total billing to date column.

Hey! Wait a Minute… What Day of the Week Did I Do That? My electricity bill doesn’t tell which Day of the Week I spent my Money.

Tell your customer precisely when you were there for them… tell them the Day of the Week you did the work for them… it will help trigger their memory and will result in less invoicing contraversaries.

Impress your customer by inserting an additional column after the Date column… call it “Day”. The formula in column B2 will be =TEXT(A2,”DDDD”).

You and your Customer will love your Record Keeping .