Problem with date and/or cell formatting

nova_sweet

New Member
Joined
Nov 27, 2016
Messages
31
Also if you select the entire range OR just the columns B:H
it will work for the cells in the other rows with dates

Assuming you are not adding dates or coincidentally numbers in the same range as a date in the other cells
No, no numbers or dates, only names/text
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
3,781
Office Version
365
Platform
MacOS
should be fine then
i did change a holiday date as a test to 20th jan
 

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
3,781
Office Version
365
Platform
MacOS
you are welcome
 

Watch MrExcel Video

Forum statistics

Threads
1,099,330
Messages
5,467,976
Members
406,561
Latest member
Grappledog

This Week's Hot Topics

Top