Excel 2008 : Automatically calculating day and date

[leojturner]

Hi, i'm working on a work log I can use for my own use so I can see how many hours I am working, how much over time i'm doing and things such like.

I get paid every 4 weeks and my contracted work days are Wednesday, Friday and Sunday. In my excel sheet I have a column I have named 'Date' what formula would I use so the excel sheet could automatically insert what the Day, Date and Year for those 4 weeks between pay days.

I only need it to work out the days between pay days as I intend to have a different excel sheet for each 4 weeks.

Thanks for any help, Leo

[Marcol]

Hi leojturner

Welcome to the forum.

I don't know what you are asking for, see if any of this workbook gives you some ideas.

If not post a workbook with what you have so far.

There are many ways to manipulate dates, these are only a few, plus an example of conditional formatting.