Adding Sick Time

Mar 14th, 2002, 08:22 AM

I have set up a worksheet for the year with every date on it, I would like Excel to add 12 hrs on the 1st day of each month, to my sicktime column, but not until the 1st day of every month occurs. Can it be done?

Al Chara · Mar 14th, 2002, 08:44 AM

Try using an If statement with the Date function. IF Date=first day of the month Then add 12 hours to sick column.

Hope this helps.
Kind regards, Al

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 08:22 AM	#1
Guest Posts: n/a	I have set up a worksheet for the year with every date on it, I would like Excel to add 12 hrs on the 1st day of each month, to my sicktime column, but not until the 1st day of every month occurs. Can it be done?

Mar 14th, 2002, 08:44 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Try using an If statement with the Date function. IF Date=first day of the month Then add 12 hours to sick column. Hope this helps. Kind regards, Al