day and date function

Originally Posted by Andy Pope

How can you have the same date each month? do you mean same day number such as 17th of each month?

yes the same day number. i have payments that are made the same date each month, the 4th, 5th and some others. i receive payments on other dates. it would be easier to have it automated to put the dates in each month without typing all the dates in again on a new month. i use the same sheet so i dont have trouble swapping it to other sheets.

and my system time is upto date and correct

cheers

Originally Posted by daddylonglegs

Use this formula

=A1

and format B1 as ddd

this worked for the days thank you